-- phpMyAdmin SQL Dump
-- version 2.6.2-pl1
-- http://www.phpmyadmin.net
-- 
-- Host: localhost
-- Generation Time: Nov 30, 2008 at 03:13 PM
-- Server version: 3.23.52
-- PHP Version: 4.2.3
-- 
-- Database: `University02`
-- 

-- --------------------------------------------------------

-- 
-- Table structure for table `courses`
-- 

CREATE TABLE `courses` (
  `courseID` varchar(9) NOT NULL default '',
  `courseTitle` varchar(99) NOT NULL default '',
  `courseDesc` text NOT NULL,
  `creditHours` int(2) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Dumping data for table `courses`
-- 

INSERT INTO `courses` VALUES ('ITBP312', 'IS Basics', '', 3);
INSERT INTO `courses` VALUES ('ITBP313', 'Programming 1', '', 3);
INSERT INTO `courses` VALUES ('ITBP314', 'Programming 2', '', 3);
INSERT INTO `courses` VALUES ('ITBP315', 'Math', '', 3);

-- --------------------------------------------------------

-- 
-- Table structure for table `courses_offering`
-- 

CREATE TABLE `courses_offering` (
  `offeringID` int(11) NOT NULL auto_increment,
  `courseID` varchar(9) NOT NULL default '',
  `s_yID` int(11) NOT NULL default '0',
  `sectionNo` int(2) NOT NULL default '0',
  `facID1` varchar(15) NOT NULL default '',
  `facID2` varchar(15) NOT NULL default '',
  PRIMARY KEY  (`offeringID`)
) TYPE=MyISAM AUTO_INCREMENT=5 ;

-- 
-- Dumping data for table `courses_offering`
-- 

INSERT INTO `courses_offering` VALUES (1, 'ITBP312', 4, 51, 'yacine', 'shehab');
INSERT INTO `courses_offering` VALUES (2, 'ITBP312', 4, 52, 'kamal', 'jihad');
INSERT INTO `courses_offering` VALUES (3, 'ITBP313', 4, 51, 'yasser', '');
INSERT INTO `courses_offering` VALUES (4, 'ITBP314', 4, 51, 'saeed', 'masood');

-- --------------------------------------------------------

-- 
-- Table structure for table `faculty`
-- 

CREATE TABLE `faculty` (
  `facID` varchar(15) NOT NULL default '',
  `facName` varchar(80) NOT NULL default '',
  `facPass` varchar(15) NOT NULL default '',
  `facAddress` text NOT NULL
) TYPE=MyISAM;

-- 
-- Dumping data for table `faculty`
-- 

INSERT INTO `faculty` VALUES ('yacine', 'Yacine Atif', '', '');
INSERT INTO `faculty` VALUES ('kamal', 'Kamal Ali', '', '');
INSERT INTO `faculty` VALUES ('yasser', 'Yasser Gadallah', '', '');
INSERT INTO `faculty` VALUES ('saeed', 'Saeed Al Nafar', '', '');
INSERT INTO `faculty` VALUES ('shehab', 'Ahmed Shehab', '', '');
INSERT INTO `faculty` VALUES ('ikbal', 'Ikbal Taleb', '', '');
INSERT INTO `faculty` VALUES ('junaid', 'Junaid', '', '');
INSERT INTO `faculty` VALUES ('masood', 'Masood', '', '');
INSERT INTO `faculty` VALUES ('jihad', 'Jihad', '', '');

-- --------------------------------------------------------

-- 
-- Table structure for table `semester_year`
-- 

CREATE TABLE `semester_year` (
  `s_yID` int(11) NOT NULL auto_increment,
  `semester` varchar(6) NOT NULL default '',
  `year` year(4) NOT NULL default '0000',
  PRIMARY KEY  (`s_yID`)
) TYPE=MyISAM AUTO_INCREMENT=7 ;

-- 
-- Dumping data for table `semester_year`
-- 

INSERT INTO `semester_year` VALUES (1, 'Fall', 2007);
INSERT INTO `semester_year` VALUES (2, 'Spring', 2007);
INSERT INTO `semester_year` VALUES (3, 'Summer', 2007);
INSERT INTO `semester_year` VALUES (4, 'Fall', 2008);
INSERT INTO `semester_year` VALUES (5, 'Spring', 2008);
INSERT INTO `semester_year` VALUES (6, 'Summer', 2008);

-- --------------------------------------------------------

-- 
-- Table structure for table `std_courses`
-- 

CREATE TABLE `std_courses` (
  `stdID` int(9) NOT NULL default '0',
  `offeringID` int(11) NOT NULL default '0'
) TYPE=MyISAM;

-- 
-- Dumping data for table `std_courses`
-- 

INSERT INTO `std_courses` VALUES (200610473, 1);
INSERT INTO `std_courses` VALUES (200610473, 1);
INSERT INTO `std_courses` VALUES (200610473, 1);
INSERT INTO `std_courses` VALUES (0, 3);
INSERT INTO `std_courses` VALUES (200610473, 3);

-- --------------------------------------------------------

-- 
-- Table structure for table `students`
-- 

CREATE TABLE `students` (
  `stdID` int(9) NOT NULL default '0',
  `stdName` varchar(60) NOT NULL default '',
  `stdAge` int(2) NOT NULL default '0',
  `stdAddress` text NOT NULL,
  `stdGPA` float NOT NULL default '0',
  `stdPass` varchar(15) NOT NULL default ''
) TYPE=MyISAM;

-- 
-- Dumping data for table `students`
-- 

INSERT INTO `students` VALUES (200610473, 'Azza Ahmed', 25, 'Dubai', 4, '123');
INSERT INTO `students` VALUES (200610477, 'Meera Ali', 19, 'Dubai', 3.4, '111');
INSERT INTO `students` VALUES (200613408, 'Hala Obaid Abdooli', 22, 'fujairah', 3.7, '222');
INSERT INTO `students` VALUES (200614972, 'Khulood', 20, 'Sharjah', 3.9, '972');
INSERT INTO `students` VALUES (200613182, 'Mariam Hammadi', 19, 'Sharjah', 4, '182');
INSERT INTO `students` VALUES (200513333, 'Sarah Khaled', 20, 'Dubai', 4, '333');
        